package cc.rengu.redp.bizimpl.upmp.bean;

import java.util.ArrayList;
import java.util.List;

public class MchntImportExportInitNew {
    public static List<ImportExcelColumnAttr> mchntImportBaseInfo = new ArrayList<ImportExcelColumnAttr>(){{
        add(new ImportExcelColumnAttr("mchntType"          , "商户类型"      ,"2;6;0;0;4;必填,请从列表中选择商户类型","special;00-普通商户,10-连锁商户,11-连锁商户门店,20-小微商户;" ));
        add(new ImportExcelColumnAttr("mchntName"            , "商户名称"      ,"1;6;0;1;30;必填,最大允许30位汉字、字母或数字",null ));
        add(new ImportExcelColumnAttr("mchntSimpleName"      , "商户简称"      ,"1;6;0;0;20;必填,最大允许20位汉字、字母或数字",null ));
        add(new ImportExcelColumnAttr("mchntBizAddr"        , "营业地址"      ,"1;6;0;1;85;必填,最大允许85位汉字、字母或数字",null ));
        add(new ImportExcelColumnAttr("registerProvince"      ,  "注册地址-省"      ,"2;6;0;0;1;必填,请从列表中选择省/直辖市","linkage"));
        add(new ImportExcelColumnAttr("registerCity"          ,  "注册地址-市"      ,"2;6;0;0;1;必填,请从列表中选择市","linkage"));
        add(new ImportExcelColumnAttr("registerArea"          ,  "注册地址-区"      ,"2;6;0;0;1;必填,请从列表中选择区/县","linkage"));
        add(new ImportExcelColumnAttr("mchntNature"        ,  "商户性质"      ,"2;6;0;0;4;必填,请从列表中选择商户性质","special;01-小微商户,02-个体工商户,03-企业,04-党政机关及事业单位,99-其他组织;" ));
        add(new ImportExcelColumnAttr("managementScope"       ,  "经营范围"      ,"2;6;0;0;1;必填,请从列表中选择经营范围","linkage"));
        add(new ImportExcelColumnAttr("industryType"          ,  "行业类别"      ,"2;6;0;0;1;必填,请从列表中选择行业类别","linkage"));
        add(new ImportExcelColumnAttr("signInstId"         ,  "签约机构"      ,"2;6;0;0;13;必填,请从列表中选择签约机构","fromdb;" ));
        add(new ImportExcelColumnAttr("mchntLevel"         , "商户等级"      ,"2;6;0;0;4;必填,请从列表中选择商户等级","fromdb;" ));
        add(new ImportExcelColumnAttr("mchntArea"          , "所属商圈"      ,"1;6;0;1;8;选填,最大允许8位字母或数字",null ));
        add(new ImportExcelColumnAttr("platMchntNo"        , "所属平台商户"      ,"1;6;0;1;32;选填,最大允许32位字母或数字",null ));
        add(new ImportExcelColumnAttr("groupMchntNo"       ,  "所属集团商户"      ,"1;6;0;1;32;选填,最大允许32位字母或数字",null ));
        add(new ImportExcelColumnAttr("agentMchntNo"       ,  "所属代理机构"      ,"1;6;0;1;32;选填,最大允许32位字母或数字",null ));
        add(new ImportExcelColumnAttr("mchntLng"           ,  "商户经度坐标"      ,"1;6;0;1;16;选填,最大允许16位数字、字母或符号",null ));
        add(new ImportExcelColumnAttr("mchntLat"           ,  "商户纬度坐标"      ,"1;6;0;1;16;选填,最大允许16位数字、字母或符号",null ));
        add(new ImportExcelColumnAttr("marketFlag"         ,  "自主开展营销标识"   ,"2;6;0;0;4;必填,请从列表中选择自主开展营销标识","special;Y-支持,N-不支持;" ));
        add(new ImportExcelColumnAttr("smsFlag"            ,  "发送短信标识"       ,"2;6;0;0;4;必填,请从列表中选择发送短信标识","special;Y-发送,N-不发送;" ));
        add(new ImportExcelColumnAttr("reconMailFlag"      , "邮箱发送对账单标识" ,"2;6;0;0;4;必填,请从列表中选择邮箱发送对账单标识","special;Y-发送,N-不发送;" ));
        add(new ImportExcelColumnAttr("mchntBizArea"       , "商户营业面积"      ,"1;6;0;1;32;选填,最大允许32位字母或数字",null ));
        add(new ImportExcelColumnAttr("bizStartTime"       ,  "营业开始时间"      ,"1;6;0;1;6;选填,请按HHmmss格式填写",null ));
        add(new ImportExcelColumnAttr("bizEndTime"         ,  "营业结束时间"      ,"1;6;0;1;6;选填,请按HHmmss格式填写",null ));
        add(new ImportExcelColumnAttr("employeeNum"        , "员工人数"      ,"3;6;0;1;8;选填,请输入员工人数,最大允许8位数字",null ));
        add(new ImportExcelColumnAttr("chainMchntNo"       , "所属连锁商户号"      ,"1;6;0;1;32;选填,最大允许32位字母或数字",null ));
        add(new ImportExcelColumnAttr("independentDataFlag",  "是否独立维护商户资料"      ,"2;6;0;0;4;选填,请从列表中选择是否独立维护商户资料","special;Y-是,N-否;" ));
        add(new ImportExcelColumnAttr("mchntAttr"          ,  "商户属性"      ,"2;6;0;0;4;必填,请从列表中选择商户属性","special;01-实体特约商户,10-网络特约商户,11-实体兼网络特约商户;" ));
        add(new ImportExcelColumnAttr("mchntNetworkDomain" ,  "网络域名"      ,"1;6;0;1;128;最大允许128位字符、字母或数字,如选择10-网络特约商户或11-实体兼网络特约商户则填写本栏位，否则无需填写",null ));
        add(new ImportExcelColumnAttr("icpRecordNo"        ,  "ICP备案号"      ,"1;6;0;1;32;最大允许32位汉字、数字或字母,如选择10-网络特约商户或11-实体兼网络特约商户则填写本栏位，否则无需填写",null ));
        add(new ImportExcelColumnAttr("ip"                 ,  "IP地址"      ,"1;6;0;1;32;最大允许32位字符、数字,如选择10-网络特约商户或11-实体兼网络特约商户则填写本栏位，否则无需填写",null ));
        add(new ImportExcelColumnAttr("mchntSignType"      , "商户签约类型"      ,"2;6;0;0;4;选填,请从列表中选择商户签约类型","special;00-银行级签约,01-平台级签约,02-商户级签约;" ));
        add(new ImportExcelColumnAttr("realSettleFlag"     ,  "是否开通本行卡实时清算","2;6;0;0;4;必填,请从列表中选择是否开通本行卡实时清算","special;Y-是,N-否;"));
        add(new ImportExcelColumnAttr("mchntSettleMode"    ,  "商户结算模式","2;6;0;0;4;必填,请从列表中选择商户结算模式","special;00-轧差清算,01-收支两条线;"));
        add(new ImportExcelColumnAttr("mchntDelayFlag"     ,  "商户延迟清算标志"  ,"2;6;0;0;4;必填,请从列表中选择商户延迟清算标志","special;Y-延迟清算,N-非延迟清算;"));
        add(new ImportExcelColumnAttr("cashWithdrawalFlag" ,  "开通提现标志"  ,"2;6;0;0;4;必填,请从列表中选择开通提现标志","special;Y-已开通,N-未开通;"));
        add(new ImportExcelColumnAttr("managerId"          , "客户经理工号"      ,"1;6;0;1;32;必填,最大允许32位字母或数字",null  ));
        add(new ImportExcelColumnAttr("managerName"        ,  "客户经理名称"      ,"1;6;0;1;21;必填,最大允许21位汉字、字母或数字",null ));
        add(new ImportExcelColumnAttr("contactName"        ,  "联系人姓名"      ,"1;6;0;1;10;必填,最大允许10位汉字、字母或数字",null ));
        add(new ImportExcelColumnAttr("contactCertType"    ,  "联系人证件类型"      ,"2;6;0;0;4;必填,请从列表中选择联系人证件类型","special;01-身份证,02-军官证,03-护照,04-户口薄,05-士兵证," +
                "06-港澳来往内地通行证,07-台湾同胞来往内地通行证,08-临时身份证,09-外国人居留证,10-警官证,99-其它;" ));
        add(new ImportExcelColumnAttr("contactCertNo"      ,  "联系人证件号码"      ,"1;6;0;1;32;必填,最大允许32位字母或数字",null));
        add(new ImportExcelColumnAttr("certEffectiveDate"  ,  "联系人证件生效日期"      ,"1;6;0;1;8;必填,请按yyyyMMdd格式填写",null  ));
        add(new ImportExcelColumnAttr("certExpiryDate"     , "联系人证件失效日期"      ,"1;6;0;1;8;必填,请按yyyyMMdd格式填写",null  ));
        add(new ImportExcelColumnAttr("contactPhone"       ,  "联系人手机号"      ,"3;6;0;1;11;必填,最大允许11位数字",null ));
        add(new ImportExcelColumnAttr("contactEmail"       ,  "联系人邮箱"      ,"1;6;0;1;64;选填,最大允许64位字母、符号或数字",null ));
    }};
    public static List<ImportExcelColumnAttr> mchntImportSignInfo = new ArrayList<ImportExcelColumnAttr>(){{
        add(new ImportExcelColumnAttr("licenceType"          , "营业执照注册类型"      ,"2;6;0;0;4;必填,请从列表中选择营业执照注册类型","special;00-营业执照,01-机构信用代码证,02-民办非企业登记证书,03-全国组织机构代码证," +
                "04-事业单位法人证书,05-境外企业证书,06-社会团体法人登记证书,07-工会法人资格证书,08-政府批文,09-预先核准通知书,10-其他批文或证明,11-贷款卡号,99-其他;" ));
        add(new ImportExcelColumnAttr("licenceCode"            , "经营执照注册号"      ,"1;6;0;1;64;必填,最大允许64位字母或数字",null ));
        add(new ImportExcelColumnAttr("registerCapital"      , "注册资本"      ,"1;6;0;0;20;选填,最大允许20位数字",null ));
        add(new ImportExcelColumnAttr("registerDate"        , "商户成立日期"      ,"1;6;0;1;8;选填,请按yyyyMMdd格式填写",null ));
        add(new ImportExcelColumnAttr("licenceEffectiveDate"        , "营业执照生效日期"      ,"1;6;0;1;8;选填,请按yyyyMMdd格式填写",null ));
        add(new ImportExcelColumnAttr("licenceExpiryDate"        , "营业执照失效日期"      ,"1;6;0;1;8;选填,请按yyyyMMdd格式填写",null ));
        add(new ImportExcelColumnAttr("registerProvince"      ,  "注册地址-省"      ,"2;6;0;0;1;必填,请从列表中选择省/直辖市","linkage"));
        add(new ImportExcelColumnAttr("registerCity"          ,  "注册地址-市"      ,"2;6;0;0;1;必填,请从列表中选择市","linkage"));
        add(new ImportExcelColumnAttr("registerArea"          ,  "注册地址-区"      ,"2;6;0;0;1;必填,请从列表中选择区/县","linkage"));
        add(new ImportExcelColumnAttr("registerAddr"          ,  "注册地址-详细地址"      ,"1;6;0;1;85;必填,最大允许85位字母、汉字或数字",null));
        add(new ImportExcelColumnAttr("mchntSignId"         ,  "商户签约协议号"      ,"1;6;0;0;64;选填,最大允许64位字母或数字",null ));
        add(new ImportExcelColumnAttr("artifName"         , "法人姓名"      ,"1;6;0;1;10;必填,最大允许10位汉字、字母或数字",null ));
        add(new ImportExcelColumnAttr("artifCertType"          , "法人证件类型"      ,"2;6;0;0;4;必填,请从列表中选择法人证件类型","special;01-身份证,02-军官证,03-护照,04-户口薄,05-士兵证," +
                "06-港澳来往内地通行证,07-台湾同胞来往内地通行证,08-临时身份证,09-外国人居留证,10-警官证,99-其它;" ));
        add(new ImportExcelColumnAttr("artifCertNo"        , "法人证件号码"      ,"1;6;0;1;32;必填,最大允许32位字母或数字",null ));
        add(new ImportExcelColumnAttr("certEffectiveDate"       ,  "证件生效日期"      ,"1;6;0;1;8;必填,请按yyyyMMdd格式填写",null ));
        add(new ImportExcelColumnAttr("certExpiryDate"       ,  "证件失效日期"      ,"1;6;0;1;8;必填,请按yyyyMMdd格式填写",null ));
        add(new ImportExcelColumnAttr("artifMobile"           ,  "法人手机号"      ,"3;6;0;1;11;必填,最大允许11位数字",null ));
    }};
    public static List<ImportExcelColumnAttr> mchntImportSettlInfo = new ArrayList<ImportExcelColumnAttr>(){{
        add(new ImportExcelColumnAttr("fundType"                , "资金类型"      ,"2;6;0;0;4;必填,请从列表中选择资金类型","special;00-商户结算净额,01-商户手续费;"));
        add(new ImportExcelColumnAttr("baseProdCode"            ,   "基础产品代码"      ,"2;6;0;0;4;必填,请从列表中选择基础产品代码","special;01-刷卡支付,02-付款扫码(主扫)," +
                "03-收款扫码(被扫),04-信用卡分期,05-银行卡支付,06-XX手机银行支付,07-微信支付,08-支付宝支付,09-银联云闪付,*-所有产品;"));
        add(new ImportExcelColumnAttr("settleType"              ,  "结算方式"      ,"2;6;0;0;4;必填,请从列表中选择结算方式","special;T1-T+1清算,TN-T+N清算,MT-按月清算,ST-按季清算;"));
        add(new ImportExcelColumnAttr("settleCycle"             ,   "结算周期"      ,"3;6;0;1;2;选填,请输入结算周期,最大允许2位数字",null));
        add(new ImportExcelColumnAttr("settleAcctType"          ,  "结算账户类型"      ,"2;6;0;0;4;必填,请从列表中选择结算账户类型","special;00-本行借记账户,01-本行贷记账户," +
                "02-本行存折,03-本行内部户,10-他行借记账户,11-他行贷记账户,12-他行存折,13-他行内部户;"));
        add(new ImportExcelColumnAttr("settleAcctNo"            ,  "结算账号"      ,"1;6;0;1;32;必填,最大允许32位数字",null));
        add(new ImportExcelColumnAttr("settleAcctName"          ,   "结算账户名"      ,"1;6;0;1;40;必填,最大允许40位汉字、字母或数字",null));
        add(new ImportExcelColumnAttr("settleAcctBankNo"        ,  "开户行行号"      ,"3;6;0;0;14;最大允许14位数字",null));
        add(new ImportExcelColumnAttr("settleAcctBankName"      ,   "开户行名称"      ,"1;6;0;1;40;必填,最大允许40位汉字、字母或数字",null));
        add(new ImportExcelColumnAttr("registerProvince"  ,   "开户行地址-省"      ,"2;6;0;0;1;选填,请从列表中选择省/直辖市","linkage"));
        add(new ImportExcelColumnAttr("registerCity"      ,  "开户行地址-市"      ,"2;6;0;0;1;选填,请从列表中选择市","linkage"));
        add(new ImportExcelColumnAttr("registerArea"      ,   "开户行地址-区"      ,"2;6;0;0;1;选填,请从列表中选择区/县","linkage"));
    }};

    public static List<ImportExcelColumnAttr> ImportTermInfo = new ArrayList<ImportExcelColumnAttr>(){{
        add(new ImportExcelColumnAttr("mchntNo"          , "商户编码"      ,"1;6;0;0;30;必填,最大允许30位字母或数字",null ));
        add(new ImportExcelColumnAttr("termType"            , "终端类型"      ,"2;6;0;0;4;必填,请从列表中选择终端类型","special;01-传统POS,02-有线拨号POS,03-电话POS,04-智能POS,05-mPOS,06-无线POS,07-mis终端" ));
        add(new ImportExcelColumnAttr("brandCode"      , "终端厂商"      ,"2;6;0;0;60;必填,请从列表中选择终端厂商","linkage;" ));
        add(new ImportExcelColumnAttr("modelCode"        , "终端型号"      ,"2;6;0;0;20;必填,请从列表中选择终端型号","linkage;" ));
        add(new ImportExcelColumnAttr("startTime"        , "维护开始时间"      ,"1;6;0;0;10;选填,请按yyyy-MM-dd格式填写",null ));
        add(new ImportExcelColumnAttr("termTxnStarWay"         ,  "终端交易发起方式"      ,"2;6;0;0;4;选填,请从列表中选择终端交易发起方式","special;10-现场,01-自主" ));
        add(new ImportExcelColumnAttr("termDevcTp"         ,  "条码终端设备类型"      ,"2;6;0;0;4;选填,请从列表中选择条码终端设备类型","special;01-智能 POS,02-传统POS(外接扫码/显码设备或内置扫码/显码模块)," +
                "03-收银机(外接扫码/显码设备或内置扫码/显码模块),04-自助收银终端(支持扫码或显码功能),05-智能移动设备（包含手机、PAD）,99-其他设备" ));
        add(new ImportExcelColumnAttr("reserve1"        , "终端地理位置校验方式"      ,"2;6;0;0;4;必填,请从列表中选择地理位置校验方式","special;0-地区代码,1-经纬度" ));
        add(new ImportExcelColumnAttr("termAddrPrvnc"      ,  "布放实体店-省"      ,"2;6;0;0;1;必填,请从列表中选择省/直辖市","linkage"));
        add(new ImportExcelColumnAttr("termAddrCity"          ,  "布放实体店-市"      ,"2;6;0;0;1;必填,请从列表中选择市","linkage"));
        add(new ImportExcelColumnAttr("termAddrArea"          ,  "布放实体店-区"      ,"2;6;0;0;1;必填,请从列表中选择区/县","linkage"));
        add(new ImportExcelColumnAttr("shopAttr"          ,  "布放实体店地址"      ,"1;6;0;1;42;必填,最大允许42位字母、汉字或数字",null));
        add(new ImportExcelColumnAttr("shoptime"         , "布放实体店时间"      ,"1;6;0;1;10;必填,请按yyyy-MM-dd格式填写",null ));
        add(new ImportExcelColumnAttr("sn"         , "S/N"      ,"2;6;0;1;256;必填,请从列表中选择终S/N","fromdb;" ));
        add(new ImportExcelColumnAttr("contactName"        , "终端联系人"      ,"1;6;0;1;16;选填,最大允许16位汉字、字母或数字",null ));
        add(new ImportExcelColumnAttr("contactPhone"           ,  "联系人电话"      ,"3;6;0;1;11;选填,最大允许11位数字",null ));
        add(new ImportExcelColumnAttr("longitude"           ,  "经度"      ,"1;6;0;1;16;必填,最大允许16位数字、字母或符号",null ));
        add(new ImportExcelColumnAttr("latitude"           ,  "纬度"      ,"1;6;0;1;16;必填,最大允许16位数字、字母或符号",null ));
        add(new ImportExcelColumnAttr("effectiveRadius"           ,  "有效半径（千米）"      ,"3;6;0;1;8;必填,最大允许8位数字",null ));
        add(new ImportExcelColumnAttr("singleLimitMaxAmt"           ,  "终端代付单笔限额（元）"      ,"3;6;0;1;20;必填,最大允许20位数字",null ));
        add(new ImportExcelColumnAttr("dayLimitAmt"           ,  "终端代付单日限额（元）"      ,"3;6;0;1;20;必填,最大允许20位数字",null ));
        add(new ImportExcelColumnAttr("remainLimitAmt"           ,  "终端代付可用额度（元）"      ,"3;6;0;1;20;必填,最大允许20位数字",null ));
    }};
}
